package com.icss.service.sysmanager;

import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;

import com.icss.service.BaseService;

/**
 * 系统管理
 * @author shixiaolong
 * @dateJun 21, 2012
 */
public class SysManagerService extends BaseService{
	public List<Map> getList(HttpServletRequest request){
		String page_num = req.getValue(request, "page_num");
		String sql="select to_char(login_date,'yyyy-MM-dd HH24:mi:ss') login_date," +
				"is_success,to_char(kill_date,'yyyy-MM-dd HH24:mi:ss') kill_date,ip_address," +
				"(select nickname from tbl_user b where b.userid=a.user_id and rownum<2 ) nickname " +
				"from TBL_LOGIN_HIS a order by login_date desc,kill_date desc";
		return db.getForList(sql, Integer.parseInt(page_num), request);
	}
}
